drop table lbk1.actor purge;
create table lbk1.actor
(
actor_id int primary key not null,
first_name varchar2(10),
last_name varchar2(10),
last_update timestamp,
create_time timestamp(3),
insert_time timestamp WITH TIME ZONE,
update_time TIMESTAMP WITH LOCAL TIME ZONE,
join_date date,
profile raw(10),
idcard char(18),
idcard2 nchar(18)
);

insert into lbk1.actor values (1, 'liao', 'BK', current_timestamp, current_timestamp, current_timestamp, current_timestamp, sysdate, UTL_RAW.cast_to_raw('abc'), '44538', '44539');
insert into lbk1.actor values (2, 'liao', 'BK', current_timestamp, current_timestamp, current_timestamp, current_timestamp, sysdate, hextoraw('abc'), '44538', '44539');

alter table lbk1.actor add duration INTERVAL DAY(3) TO SECOND (4);

#####
SELECT TIMESTAMP '2023-10-01 12:00:00' AT TIME ZONE 'America/New_York' FROM DUAL;
不支持含时区timestamp如:
TIMESTAMP '2023-10-01 12:00:00' AT TIME ZONE 'America/New_York'
insert into lbk1.actor (actor_id,insert_time) values (999, TIMESTAMP '2023-10-01 12:00:00' AT TIME ZONE 'America/New_York');
insert into lbk1.actor (actor_id,update_time) values (1000, TIMESTAMP '2023-10-01 12:00:00' AT TIME ZONE 'America/New_York');
#####


INSERT INTO lbk1.actor (actor_id, first_name, duration) VALUES (3, 'test', INTERVAL '3' DAY);
INSERT INTO lbk1.actor (actor_id, first_name, duration) VALUES (4, 'test', INTERVAL '3 2:25:45' DAY TO SECOND);

alter table lbk1.actor add duration2 INTERVAL YEAR(3) TO MONTH;
INSERT INTO lbk1.actor (actor_id, first_name, duration2) VALUES (5, 'test', interval '1-3' year to month);

alter table lbk1.actor add memory float(10);
INSERT INTO lbk1.actor (actor_id, first_name, memory) VALUES (6, 'test', 9999.101);

alter table lbk1.actor add memory1 BINARY_FLOAT;
alter table lbk1.actor add memory2 BINARY_DOUBLE;

INSERT INTO lbk1.actor (actor_id, first_name, memory1, memory2) VALUES (7, 'test', 1111.101, 2222.101);

alter table lbk1.actor add text long;
INSERT INTO lbk1.actor (actor_id, text) VALUES (8, 'test');

alter table lbk1.actor add image blob;
INSERT INTO lbk1.actor (actor_id, image) VALUES (9, hextoraw('1234'));

alter table lbk1.actor add conf xmltype;
INSERT INTO lbk1.actor (actor_id, conf) VALUES (10, '<employee><name>John Doe</name><age>30</age></employee>');




create table lbk1.test
(
    a int not null,
    b int not null,
    c int not null,
    d int not null,
    e int not null
);
create unique index idx_test_1 on lbk1.test(d,a,e);

insert into lbk1.test values (1,2,3,4,5);
insert into lbk1.test values (11,12,13,14,15);